import xlrd
family_excel = xlrd.open_workbook(r'C:\Users\Administrator\Desktop\family.xls')
a = family_excel.nsheets
print(a)
b = family_excel.sheets()
print(b)
c = family_excel.sheet_names()
print(c)
d = family_excel.sheets()[0]
e = family_excel.sheet_by_index(0)
f = family_excel.sheet_by_name('Sheet1')
print(d,e,f)
g = d.nrows
h = d.ncols
i = d.name
print(g,h,i)
j = d.row_values(1)
k = d.col_values(1)
print(j,k)
l = d.cell_value(1,0)
m = d.cell(1,0).value
print(l,m)
n = xlrd.xldate_as_tuple(d.cell(2,1).value,0)
o = xlrd.xldate_as_tuple(d.cell(2,1).value,1)
print(n,o)
p = xlrd.xldate_as_datetime(d.cell(2,1).value,0)
r = xlrd.xldate_as_datetime(d.cell(2,1).value,1)
print(p,r)
